﻿using System;

namespace edowork.com.Model
{
    #region purchasedetailInfo

        [Serializable]
        public class purchasedetailInfo
        {
            #region Private fields

            protected string _pcsid = String.Empty;
            protected string _productcode = String.Empty;
            protected decimal _in_qty;
            protected decimal _in_price;
            protected decimal _in_money;
            protected string _remark = String.Empty;

            #endregion

            public purchasedetailInfo() { }

            #region Public Properties

            public string Pcsid
            {
                get { return _pcsid; }
                set { _pcsid = value; }
            }

            public string Productcode
            {
                get { return _productcode; }
                set { _productcode = value; }
            }

            public decimal In_qty
            {
                get { return _in_qty; }
                set { _in_qty = value; }
            }

            public decimal In_price
            {
                get { return _in_price; }
                set { _in_price = value; }
            }

            public decimal In_money
            {
                get { return _in_money; }
                set { _in_money = value; }
            }

            public string Remark
            {
                get { return _remark; }
                set { _remark = value; }
            }

            #endregion

            #region Public SQL Script

            public string SQL_Insert()
            {
                return "insert into purchasedetail(Pcsid,Productcode,In_qty,In_price,In_money,Remark) values('{0}','{1}',{2},{3},{4},'{5}')";
            }

            #endregion

        }

        #endregion
}

